Enterprise Database Systems
Design Data Models in Power BI
Power BI Data Model Design: Advanced Modeling Technique
it_dfdpbi_05_enus
Power BI Data Model Design: An Overview of Data Modeling
it_dfdpbi_01_enus
Power BI Data Model Design: Applying the DAX Formula Language
it_dfdpbi_02_enus
Power BI Data Model Design: Using Time Intelligence
it_dfdpbi_04_enus
Power BI Data Model Design: Working with Filters
it_dfdpbi_03_enus
Power BI Data Model Design: Advanced Modeling Technique
Lesson Objectives
Power BI Data Model Design: Advanced Modeling Technique
- discover the key concepts covered in this course
- load fact and dimension tables containing sales data for analysis
- recognize the types of relationships that Power BI can detect and apply automatically when data is loaded
- search for a value in a related table without establishing a relationship
- use bi-directional cross-filtering to perform an aggregation that is not possible with single-direction cross-filtering
- identify the types of cardinalities that can be applied to different types of relationships
- define a hierarchy of fields containing geographical information
- apply a geographical hierarchy in a Power BI visualization
- set the default aggregation on a field to compute the average
- combine related fields across tables into a single unit and configure them together
- recognize the benefits and limitations of Power BI's auto date/time feature
- create a table containing user information as a prelude to setting up row-level security
- set up permissions so that users can only view their own information when analyzing data with Power BI
- navigate over reports as different users in Power BI Desktop in order to ensure the correct implementation of row-level security
- summarize the key concepts covered in this course
Overview/Description
A well-designed data model eliminates irrelevant and uninterpretable analyses and ensures insightful and well-performing reports. Use this course to step up your data analysis using Power BI's advanced data modeling features. Begin by loading a sales dataset containing a large fact table and multiple dimension tables and modeling it into a snowflake schema. See how Power BI automatically detects relationships. Then, learn how to apply detailed configurations of relationships, from setting the right cardinality to applying bi-directional cross-filtering. Next, explicitly define a hierarchy in your data to model a set of geographical values. Learn further detailed configurations, such as setting a default aggregation operation on fields and hiding specific ones from the reports view. Lastly, learn how to implement row-level security. When you're done, you'll be able to use Power BI's advanced data modeling capabilities. You'll also be further prepared for the DA-100: Analyzing Data with Microsoft Power BI certification exam.
A well-designed data model eliminates irrelevant and uninterpretable analyses and ensures insightful and well-performing reports. Use this course to step up your data analysis using Power BI's advanced data modeling features. Begin by loading a sales dataset containing a large fact table and multiple dimension tables and modeling it into a snowflake schema. See how Power BI automatically detects relationships. Then, learn how to apply detailed configurations of relationships, from setting the right cardinality to applying bi-directional cross-filtering. Next, explicitly define a hierarchy in your data to model a set of geographical values. Learn further detailed configurations, such as setting a default aggregation operation on fields and hiding specific ones from the reports view. Lastly, learn how to implement row-level security. When you're done, you'll be able to use Power BI's advanced data modeling capabilities. You'll also be further prepared for the DA-100: Analyzing Data with Microsoft Power BI certification exam.
Target
Prerequisites: none
Power BI Data Model Design: An Overview of Data Modeling
Lesson Objectives
Power BI Data Model Design: An Overview of Data Modeling
- discover the key concepts covered in this course
- identify some of the critical steps involved in modeling data for analysis in Power BI
- recognize what the star schema is and why it's crucial in the context of data analysis in Power BI
- summarize the power of the DAX formula language and the types of operations it can perform
- describe the important techniques for optimizing data for performance when modeling data in Power BI
- use the UNION operation to combine the contents of two tables with identical schemas
- apply a DAX formula to compute a value based on existing data for each row in a table
- define a measure using the DAX formula language and contrast it with a calculated column
- create a simple table visual in order to view data stored in tables
- model a numeric value as a discrete rating on a 0-5 scale
- count the number of values in a column based on an expression
- summarize the key concepts covered in this course
Overview/Description
Data as a form of currency is an analogy that's been around since the early 2000s. However, data itself is worthless. The real value is in the insights you gain from it; this is where data analysis comes in. Data modeling is a crucial part of data analysis, helping turn raw data into accurate insights and meaningful reports. Use this course to learn how to design and optimize data models through Power BI Desktop. Examine the star and snowflake schemas. Learn about the DAX formula language. Then, conduct a range of tasks, including combining tables, defining calculated columns, creating measures, and counting values. Upon course completion, you'll know how to use data modeling to transform raw data into powerful visuals and reports. You'll also be further prepared for the DA-100: Analyzing Data with Microsoft Power BI certification exam.
Data as a form of currency is an analogy that's been around since the early 2000s. However, data itself is worthless. The real value is in the insights you gain from it; this is where data analysis comes in. Data modeling is a crucial part of data analysis, helping turn raw data into accurate insights and meaningful reports. Use this course to learn how to design and optimize data models through Power BI Desktop. Examine the star and snowflake schemas. Learn about the DAX formula language. Then, conduct a range of tasks, including combining tables, defining calculated columns, creating measures, and counting values. Upon course completion, you'll know how to use data modeling to transform raw data into powerful visuals and reports. You'll also be further prepared for the DA-100: Analyzing Data with Microsoft Power BI certification exam.
Target
Prerequisites: none
Power BI Data Model Design: Applying the DAX Formula Language
Lesson Objectives
Power BI Data Model Design: Applying the DAX Formula Language
- discover the key concepts covered in this course
- import multiple related tables into Power BI Desktop
- use the DAX language to calculate a sum of values based on an operation performed on raw data
- compute the average of a value derived from the data in a table
- use the BLANK function to generate blank values
- perform a variety of count operations using the different count functions available in DAX
- perform operations on a subset of data in a table
- define a DAX formula using nested IF function calls
- set the operations to be performed in different scenarios using the SWITCH function
- summarize the key concepts covered in this course
Overview/Description
Power BI does the heavy lifting when it comes to analyzing data. One way it does this is through the DAX formula language. By learning how to use this language, you can vastly improve the insights you get from data. Use this course to learn how to conduct several data analysis operations using the DAX formula language. Begin by performing aggregation operations, such as sum and average. Learn how to generate and work with blank data in DAX. Explore a variety of counting functions, ranging from simple counts of values to conditional counts based on filters. Lastly, practice using the IF and SWITCH functions. Upon course completion, you'll know how to use DAX to calculate values and reference table data in Power BI. You'll also be further prepared for the DA-100: Analyzing Data with Microsoft Power BI certification exam.
Power BI does the heavy lifting when it comes to analyzing data. One way it does this is through the DAX formula language. By learning how to use this language, you can vastly improve the insights you get from data. Use this course to learn how to conduct several data analysis operations using the DAX formula language. Begin by performing aggregation operations, such as sum and average. Learn how to generate and work with blank data in DAX. Explore a variety of counting functions, ranging from simple counts of values to conditional counts based on filters. Lastly, practice using the IF and SWITCH functions. Upon course completion, you'll know how to use DAX to calculate values and reference table data in Power BI. You'll also be further prepared for the DA-100: Analyzing Data with Microsoft Power BI certification exam.
Target
Prerequisites: none
Power BI Data Model Design: Using Time Intelligence
Lesson Objectives
Power BI Data Model Design: Using Time Intelligence
- discover the key concepts covered in this course
- define a date table to represent a date using a variety of dimensions and formats
- set a relationship between a date table and a fact table
- modify the range of dates in the current context using the DATEADD function
- perform year-to-date and month-to-date computations on data by altering the current context
- calculate the year-to-date sales values using the TOTALYTD function
- summarize the key concepts covered in this course
Overview/Description
A big part of data analysis is evaluating how data behaves over time. Power BI's DAX language includes time intelligence functions that enable you to aggregate, compare, and manipulate data using time periods. Use this course to learn how to model data using time-based analysis. Begin by creating a date table. Then use DAX time intelligence functions to extract values from a date. Also, learn how to define dates as a hierarchy, which can then be applied in visualizations. Moving along, practice operating on a range of dates that are shifted from the range in the current context by a specified interval. Finally, perform year-to-date and month-to-date computations from the date in the current context. When you're done, you'll be able to apply a variety of time functions to your data. You'll also be further prepared for the DA-100: Analyzing Data with Microsoft Power BI certification exam.
A big part of data analysis is evaluating how data behaves over time. Power BI's DAX language includes time intelligence functions that enable you to aggregate, compare, and manipulate data using time periods. Use this course to learn how to model data using time-based analysis. Begin by creating a date table. Then use DAX time intelligence functions to extract values from a date. Also, learn how to define dates as a hierarchy, which can then be applied in visualizations. Moving along, practice operating on a range of dates that are shifted from the range in the current context by a specified interval. Finally, perform year-to-date and month-to-date computations from the date in the current context. When you're done, you'll be able to apply a variety of time functions to your data. You'll also be further prepared for the DA-100: Analyzing Data with Microsoft Power BI certification exam.
Target
Prerequisites: none
Power BI Data Model Design: Working with Filters
Lesson Objectives
Power BI Data Model Design: Working with Filters
- discover the key concepts covered in this course
- use a common column to set a relationship between tables loaded into Power BI
- perform an aggregation using a key from one table and values from another related table
- define a table using the contents of another table by setting a filter context
- perform operations on a subset of data by defining a filter context
- set up a DAX function to ignore a filter context for a specific calculation
- use the ALL function to access all rows in a table by ignoring the filter context
- apply the ALLSELECTED function to ignore the context set by a visualization
- employ DAX functions to ignore the query context set by Power BI visualizations
- summarize the key concepts covered in this course
Overview/Description
The more you master DAX in Power BI, the better the insights and reports you'll get from data. The filter context is a need-to-know DAX concept. Use this course to get hands-on experience working with this aspect of Power BI. Start by exploring the relationships between tables in Power BI. Move on to using the CALCULATE function. Then, see how a filter context can be defined so that it only points to a subset of the overall data and how you can continue to perform operations within this filter context. Moving on, examine a breadth of options for ignoring the filter context for specific use cases, including how to bypass filters using various DAX functions. When you're done, you'll be able to use DAX functions to perform operations on a subset of data. You'll also be further prepared for the DA-100: Analyzing Data with Microsoft Power BI certification exam.
The more you master DAX in Power BI, the better the insights and reports you'll get from data. The filter context is a need-to-know DAX concept. Use this course to get hands-on experience working with this aspect of Power BI. Start by exploring the relationships between tables in Power BI. Move on to using the CALCULATE function. Then, see how a filter context can be defined so that it only points to a subset of the overall data and how you can continue to perform operations within this filter context. Moving on, examine a breadth of options for ignoring the filter context for specific use cases, including how to bypass filters using various DAX functions. When you're done, you'll be able to use DAX functions to perform operations on a subset of data. You'll also be further prepared for the DA-100: Analyzing Data with Microsoft Power BI certification exam.
Target
Prerequisites: none
